Dataset statistics
| Number of variables | 9 |
|---|---|
| Number of observations | 552 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 38.9 KiB |
| Average record size in memory | 72.2 B |
Variable types
| DateTime | 1 |
|---|---|
| Numeric | 8 |
Variable descriptions
| Natural Gas Price, Wellhead | Price from source |
|---|---|
| Natural Gas Price, Citygate | Point of distribution |
| Natural Gas Price, Delivered to Consumers, Residential | Average price paid for by residential users |
| Natural Gas Price, Delivered to Consumers, Commercial | Average price paid for by commercial users |
| Natural Gas Price, Delivered to Consumers, Industrial | Average price paid for by industrial users |
Natural Gas Price, Wellhead is highly correlated with Natural Gas Price, Citygate and 4 other fields | High correlation |
Natural Gas Price, Citygate is highly correlated with Natural Gas Price, Wellhead and 4 other fields | High correlation |
Natural Gas Price, Delivered to Consumers, Residential is highly correlated with Natural Gas Price, Wellhead and 3 other fields | High correlation |
Natural Gas Price, Delivered to Consumers, Commercial is highly correlated with Natural Gas Price, Wellhead and 4 other fields | High correlation |
Natural Gas Price, Delivered to Consumers, Industrial is highly correlated with Natural Gas Price, Wellhead and 3 other fields | High correlation |
Natural Gas Price, Electric Power Sector is highly correlated with Natural Gas Price, Wellhead and 4 other fields | High correlation |
Natural Gas Price, Wellhead is highly correlated with Natural Gas Price, Citygate and 4 other fields | High correlation |
Natural Gas Price, Citygate is highly correlated with Natural Gas Price, Wellhead and 4 other fields | High correlation |
Natural Gas Price, Delivered to Consumers, Residential is highly correlated with Natural Gas Price, Wellhead and 4 other fields | High correlation |
Natural Gas Price, Delivered to Consumers, Commercial is highly correlated with Natural Gas Price, Wellhead and 4 other fields | High correlation |
Natural Gas Price, Delivered to Consumers, Industrial is highly correlated with Natural Gas Price, Wellhead and 4 other fields | High correlation |
Natural Gas Price, Electric Power Sector is highly correlated with Natural Gas Price, Wellhead and 4 other fields | High correlation |
Natural Gas Price, Wellhead is highly correlated with Natural Gas Price, Citygate and 4 other fields | High correlation |
Natural Gas Price, Citygate is highly correlated with Natural Gas Price, Wellhead and 3 other fields | High correlation |
Natural Gas Price, Delivered to Consumers, Residential is highly correlated with Natural Gas Price, Wellhead and 2 other fields | High correlation |
Natural Gas Price, Delivered to Consumers, Commercial is highly correlated with Natural Gas Price, Wellhead and 4 other fields | High correlation |
Natural Gas Price, Delivered to Consumers, Industrial is highly correlated with Natural Gas Price, Wellhead and 3 other fields | High correlation |
Natural Gas Price, Electric Power Sector is highly correlated with Natural Gas Price, Wellhead and 4 other fields | High correlation |
Year is highly correlated with Natural Gas Price, Wellhead and 5 other fields | High correlation |
Month is highly correlated with Natural Gas Price, Delivered to Consumers, Residential | High correlation |
Natural Gas Price, Wellhead is highly correlated with Year and 5 other fields | High correlation |
Natural Gas Price, Citygate is highly correlated with Year and 5 other fields | High correlation |
Natural Gas Price, Delivered to Consumers, Residential is highly correlated with Year and 6 other fields | High correlation |
Natural Gas Price, Delivered to Consumers, Commercial is highly correlated with Year and 5 other fields | High correlation |
Natural Gas Price, Delivered to Consumers, Industrial is highly correlated with Year and 5 other fields | High correlation |
Natural Gas Price, Electric Power Sector is highly correlated with Year and 5 other fields | High correlation |
Date has unique values | Unique |
Reproduction
| Analysis started | 2022-08-09 01:06:12.774926 |
|---|---|
| Analysis finished | 2022-08-09 01:06:30.138600 |
| Duration | 17.36 seconds |
| Software version | pandas-profiling v3.2.0 |
| Download configuration | config.json |
| Distinct | 552 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.4 KiB |
| Minimum | 1976-01-01 00:00:00 |
|---|---|
| Maximum | 2021-12-01 00:00:00 |
| Distinct | 46 |
|---|---|
| Distinct (%) | 8.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1998.5 |
| Minimum | 1976 |
|---|---|
| Maximum | 2021 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 KiB |
Quantile statistics
| Minimum | 1976 |
|---|---|
| 5-th percentile | 1978 |
| Q1 | 1987 |
| median | 1998.5 |
| Q3 | 2010 |
| 95-th percentile | 2019 |
| Maximum | 2021 |
| Range | 45 |
| Interquartile range (IQR) | 23 |
Descriptive statistics
| Standard deviation | 13.2879597 |
|---|---|
| Coefficient of variation (CV) | 0.006648966574 |
| Kurtosis | -1.201137149 |
| Mean | 1998.5 |
| Median Absolute Deviation (MAD) | 11.5 |
| Skewness | 0 |
| Sum | 1103172 |
| Variance | 176.569873 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 1976 | 12 | 2.2% |
| 2010 | 12 | 2.2% |
| 2001 | 12 | 2.2% |
| 2002 | 12 | 2.2% |
| 2003 | 12 | 2.2% |
| 2004 | 12 | 2.2% |
| 2005 | 12 | 2.2% |
| 2006 | 12 | 2.2% |
| 2007 | 12 | 2.2% |
| 2008 | 12 | 2.2% |
| Other values (36) | 432 |
| Value | Count | Frequency (%) |
| 1976 | 12 | |
| 1977 | 12 | |
| 1978 | 12 | |
| 1979 | 12 | |
| 1980 | 12 | |
| 1981 | 12 | |
| 1982 | 12 | |
| 1983 | 12 | |
| 1984 | 12 | |
| 1985 | 12 |
| Value | Count | Frequency (%) |
| 2021 | 12 | |
| 2020 | 12 | |
| 2019 | 12 | |
| 2018 | 12 | |
| 2017 | 12 | |
| 2016 | 12 | |
| 2015 | 12 | |
| 2014 | 12 | |
| 2013 | 12 | |
| 2012 | 12 |
| Distinct | 12 |
|---|---|
| Distinct (%) | 2.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.5 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3.75 |
| median | 6.5 |
| Q3 | 9.25 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 5.5 |
Descriptive statistics
| Standard deviation | 3.455183644 |
|---|---|
| Coefficient of variation (CV) | 0.5315667144 |
| Kurtosis | -1.216928288 |
| Mean | 6.5 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0 |
| Sum | 3588 |
| Variance | 11.93829401 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 46 | |
| 2 | 46 | |
| 3 | 46 | |
| 4 | 46 | |
| 5 | 46 | |
| 6 | 46 | |
| 7 | 46 | |
| 8 | 46 | |
| 9 | 46 | |
| 10 | 46 | |
| Other values (2) | 92 |
| Value | Count | Frequency (%) |
| 1 | 46 | |
| 2 | 46 | |
| 3 | 46 | |
| 4 | 46 | |
| 5 | 46 | |
| 6 | 46 | |
| 7 | 46 | |
| 8 | 46 | |
| 9 | 46 | |
| 10 | 46 |
| Value | Count | Frequency (%) |
| 12 | 46 | |
| 11 | 46 | |
| 10 | 46 | |
| 9 | 46 | |
| 8 | 46 | |
| 7 | 46 | |
| 6 | 46 | |
| 5 | 46 | |
| 4 | 46 | |
| 3 | 46 |
Natural Gas Price, Wellhead
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONPrice from source
| Distinct | 270 |
|---|---|
| Distinct (%) | 48.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.846503623 |
| Minimum | 0.54 |
|---|---|
| Maximum | 10.79 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 KiB |
Quantile statistics
| Minimum | 0.54 |
|---|---|
| 5-th percentile | 0.89 |
| Q1 | 1.8 |
| median | 2.46 |
| Q3 | 3.35 |
| 95-th percentile | 6.469 |
| Maximum | 10.79 |
| Range | 10.25 |
| Interquartile range (IQR) | 1.55 |
Descriptive statistics
| Standard deviation | 1.711662119 |
|---|---|
| Coefficient of variation (CV) | 0.6013208994 |
| Kurtosis | 3.623537146 |
| Mean | 2.846503623 |
| Median Absolute Deviation (MAD) | 0.7 |
| Skewness | 1.75198663 |
| Sum | 1571.27 |
| Variance | 2.929787209 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 3.35 | 22 | 4.0% |
| 1.89 | 13 | 2.4% |
| 1.94 | 13 | 2.4% |
| 2.71 | 12 | 2.2% |
| 2.86 | 11 | 2.0% |
| 2.25 | 11 | 2.0% |
| 2.59 | 11 | 2.0% |
| 3.03 | 10 | 1.8% |
| 2.54 | 10 | 1.8% |
| 2.46 | 10 | 1.8% |
| Other values (260) | 429 |
| Value | Count | Frequency (%) |
| 0.54 | 3 | |
| 0.55 | 2 | |
| 0.58 | 2 | |
| 0.6 | 2 | |
| 0.62 | 1 | 0.2% |
| 0.63 | 1 | 0.2% |
| 0.64 | 1 | 0.2% |
| 0.67 | 1 | 0.2% |
| 0.71 | 1 | 0.2% |
| 0.75 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 10.79 | 1 | |
| 10.36 | 1 | |
| 10.33 | 1 | |
| 9.96 | 1 | |
| 9.89 | 1 | |
| 9.08 | 1 | |
| 8.95 | 1 | |
| 8.87 | 1 | |
| 8.63 | 1 | |
| 8.21 | 1 |
Natural Gas Price, Citygate
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONPoint of distribution
| Distinct | 273 |
|---|---|
| Distinct (%) | 49.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.495072464 |
| Minimum | 2.61 |
|---|---|
| Maximum | 12.48 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 KiB |
Quantile statistics
| Minimum | 2.61 |
|---|---|
| 5-th percentile | 2.83 |
| Q1 | 3.2475 |
| median | 3.97 |
| Q3 | 5.2025 |
| 95-th percentile | 8.178 |
| Maximum | 12.48 |
| Range | 9.87 |
| Interquartile range (IQR) | 1.955 |
Descriptive statistics
| Standard deviation | 1.750402389 |
|---|---|
| Coefficient of variation (CV) | 0.38940471 |
| Kurtosis | 3.7004735 |
| Mean | 4.495072464 |
| Median Absolute Deviation (MAD) | 0.82 |
| Skewness | 1.807867032 |
| Sum | 2481.28 |
| Variance | 3.063908525 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4.02 | 28 | 5.1% |
| 3.91 | 19 | 3.4% |
| 3.69 | 12 | 2.2% |
| 3.97 | 11 | 2.0% |
| 3.94 | 10 | 1.8% |
| 3.96 | 10 | 1.8% |
| 2.92 | 9 | 1.6% |
| 4.06 | 9 | 1.6% |
| 3.98 | 9 | 1.6% |
| 3.88 | 8 | 1.4% |
| Other values (263) | 427 |
| Value | Count | Frequency (%) |
| 2.61 | 1 | 0.2% |
| 2.67 | 1 | 0.2% |
| 2.69 | 1 | 0.2% |
| 2.7 | 1 | 0.2% |
| 2.71 | 1 | 0.2% |
| 2.72 | 1 | 0.2% |
| 2.74 | 4 | |
| 2.75 | 1 | 0.2% |
| 2.76 | 2 | |
| 2.77 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 12.48 | 1 | |
| 12.45 | 1 | |
| 12.16 | 1 | |
| 11.85 | 1 | |
| 11.57 | 1 | |
| 11.05 | 1 | |
| 10.8 | 1 | |
| 10.77 | 1 | |
| 10.26 | 1 | |
| 10.2 | 1 |
Natural Gas Price, Delivered to Consumers, Residential
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONAverage price paid for by residential users
| Distinct | 405 |
|---|---|
| Distinct (%) | 73.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8.978331032 |
| Minimum | 1.98 |
|---|---|
| Maximum | 20.98 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 KiB |
Quantile statistics
| Minimum | 1.98 |
|---|---|
| 5-th percentile | 4.06 |
| Q1 | 5.86 |
| median | 7.835 |
| Q3 | 11.6825 |
| 95-th percentile | 16.688 |
| Maximum | 20.98 |
| Range | 19 |
| Interquartile range (IQR) | 5.8225 |
Descriptive statistics
| Standard deviation | 4.063063664 |
|---|---|
| Coefficient of variation (CV) | 0.4525410847 |
| Kurtosis | -0.3251565239 |
| Mean | 8.978331032 |
| Median Absolute Deviation (MAD) | 2.39 |
| Skewness | 0.7254482452 |
| Sum | 4956.038729 |
| Variance | 16.50848634 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4.3 | 7 | 1.3% |
| 3.94 | 6 | 1.1% |
| 4.55 | 6 | 1.1% |
| 4.53 | 6 | 1.1% |
| 3.99 | 6 | 1.1% |
| 4.47 | 6 | 1.1% |
| 4.5 | 6 | 1.1% |
| 4.32 | 6 | 1.1% |
| 4.06 | 6 | 1.1% |
| 6.84 | 5 | 0.9% |
| Other values (395) | 492 |
| Value | Count | Frequency (%) |
| 1.98 | 2 | 0.4% |
| 2.35 | 3 | |
| 2.443745893 | 1 | 0.2% |
| 2.56 | 2 | 0.4% |
| 2.907491785 | 1 | 0.2% |
| 2.98 | 2 | 0.4% |
| 3.371237678 | 1 | 0.2% |
| 3.68 | 2 | 0.4% |
| 3.836254107 | 1 | 0.2% |
| 3.94 | 6 |
| Value | Count | Frequency (%) |
| 20.98 | 1 | |
| 20.77 | 1 | |
| 20.25 | 1 | |
| 20.17 | 1 | |
| 19.94 | 1 | |
| 18.91 | 1 | |
| 18.56 | 1 | |
| 18.41 | 1 | |
| 18.37 | 1 | |
| 18.27 | 1 |
Natural Gas Price, Delivered to Consumers, Commercial
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONAverage price paid for by commercial users
| Distinct | 333 |
|---|---|
| Distinct (%) | 60.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.942392867 |
| Minimum | 1.64 |
|---|---|
| Maximum | 15.64 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 KiB |
Quantile statistics
| Minimum | 1.64 |
|---|---|
| 5-th percentile | 4.5655 |
| Q1 | 5.2975 |
| median | 5.67 |
| Q3 | 8.52 |
| 95-th percentile | 11.2345 |
| Maximum | 15.64 |
| Range | 14 |
| Interquartile range (IQR) | 3.2225 |
Descriptive statistics
| Standard deviation | 2.350336658 |
|---|---|
| Coefficient of variation (CV) | 0.3385484952 |
| Kurtosis | 0.4191607038 |
| Mean | 6.942392867 |
| Median Absolute Deviation (MAD) | 1.08 |
| Skewness | 0.7945952082 |
| Sum | 3832.200862 |
| Variance | 5.524082406 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 5.62 | 17 | 3.1% |
| 5.6 | 12 | 2.2% |
| 5.49 | 10 | 1.8% |
| 5.57 | 10 | 1.8% |
| 5.47 | 10 | 1.8% |
| 5.53 | 10 | 1.8% |
| 5.67 | 10 | 1.8% |
| 5.54 | 10 | 1.8% |
| 4.77 | 5 | 0.9% |
| 5.46 | 5 | 0.9% |
| Other values (323) | 453 |
| Value | Count | Frequency (%) |
| 1.64 | 2 | |
| 2.04 | 3 | |
| 2.143405202 | 1 | 0.2% |
| 2.23 | 2 | |
| 2.646810404 | 1 | 0.2% |
| 2.73 | 2 | |
| 3.150215606 | 1 | 0.2% |
| 3.39 | 2 | |
| 3.655 | 1 | 0.2% |
| 4 | 2 |
| Value | Count | Frequency (%) |
| 15.64 | 1 | |
| 14.76 | 1 | |
| 14.68 | 1 | |
| 14.29 | 1 | |
| 14.19 | 1 | |
| 14.16 | 1 | |
| 14.01 | 1 | |
| 13.51 | 1 | |
| 13.12 | 1 | |
| 12.95 | 1 |
Natural Gas Price, Delivered to Consumers, Industrial
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONAverage price paid for by industrial users
| Distinct | 296 |
|---|---|
| Distinct (%) | 53.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.311452995 |
| Minimum | 1.24 |
|---|---|
| Maximum | 13.06 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 KiB |
Quantile statistics
| Minimum | 1.24 |
|---|---|
| 5-th percentile | 2.54 |
| Q1 | 3.1075 |
| median | 4.02 |
| Q3 | 4.73 |
| 95-th percentile | 7.9245 |
| Maximum | 13.06 |
| Range | 11.82 |
| Interquartile range (IQR) | 1.6225 |
Descriptive statistics
| Standard deviation | 1.760560712 |
|---|---|
| Coefficient of variation (CV) | 0.4083451018 |
| Kurtosis | 4.120697728 |
| Mean | 4.311452995 |
| Median Absolute Deviation (MAD) | 0.88 |
| Skewness | 1.769622585 |
| Sum | 2379.922053 |
| Variance | 3.099574021 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4.29 | 18 | 3.3% |
| 4.31 | 11 | 2.0% |
| 4.15 | 10 | 1.8% |
| 4.24 | 10 | 1.8% |
| 4.21 | 10 | 1.8% |
| 4.14 | 9 | 1.6% |
| 4.17 | 9 | 1.6% |
| 4.25 | 9 | 1.6% |
| 3 | 5 | 0.9% |
| 3.02 | 5 | 0.9% |
| Other values (286) | 456 |
| Value | Count | Frequency (%) |
| 1.24 | 2 | |
| 1.5 | 3 | |
| 1.598504449 | 1 | 0.2% |
| 1.7 | 2 | |
| 1.957008898 | 1 | 0.2% |
| 1.99 | 2 | |
| 2.23 | 1 | 0.2% |
| 2.26 | 1 | 0.2% |
| 2.29 | 1 | 0.2% |
| 2.315513347 | 1 | 0.2% |
| Value | Count | Frequency (%) |
| 13.06 | 1 | |
| 12.11 | 2 | |
| 12.06 | 1 | |
| 11.35 | 1 | |
| 11.17 | 1 | |
| 10.85 | 1 | |
| 10.18 | 1 | |
| 10.1 | 1 | |
| 10.03 | 1 | |
| 9.61 | 1 |
Natural Gas Price, Electric Power Sector
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 312 |
|---|---|
| Distinct (%) | 56.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.705434783 |
| Minimum | 1.06 |
|---|---|
| Maximum | 16.29 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.4 KiB |
Quantile statistics
| Minimum | 1.06 |
|---|---|
| 5-th percentile | 1.84 |
| Q1 | 2.37 |
| median | 3.12 |
| Q3 | 4.45 |
| 95-th percentile | 7.5645 |
| Maximum | 16.29 |
| Range | 15.23 |
| Interquartile range (IQR) | 2.08 |
Descriptive statistics
| Standard deviation | 1.962010939 |
|---|---|
| Coefficient of variation (CV) | 0.529495472 |
| Kurtosis | 5.240899076 |
| Mean | 3.705434783 |
| Median Absolute Deviation (MAD) | 0.865 |
| Skewness | 1.912437755 |
| Sum | 2045.4 |
| Variance | 3.849486925 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1.87 | 8 | 1.4% |
| 3.23 | 6 | 1.1% |
| 1.84 | 6 | 1.1% |
| 3.72 | 6 | 1.1% |
| 3.07 | 6 | 1.1% |
| 2.22 | 5 | 0.9% |
| 2.45 | 5 | 0.9% |
| 1.96 | 5 | 0.9% |
| 1.9 | 5 | 0.9% |
| 2.44 | 5 | 0.9% |
| Other values (302) | 495 |
| Value | Count | Frequency (%) |
| 1.06 | 2 | 0.4% |
| 1.32 | 4 | |
| 1.48 | 2 | 0.4% |
| 1.55 | 4 | |
| 1.58 | 1 | 0.2% |
| 1.65 | 4 | |
| 1.69 | 4 | |
| 1.7 | 1 | 0.2% |
| 1.82 | 1 | 0.2% |
| 1.84 | 6 |
| Value | Count | Frequency (%) |
| 16.29 | 1 | |
| 12.41 | 1 | |
| 11.84 | 1 | |
| 11.71 | 1 | |
| 11.26 | 1 | |
| 10.99 | 1 | |
| 10.97 | 1 | |
| 10.19 | 1 | |
| 9.87 | 1 | |
| 9.55 | 1 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| Date | Year | Month | Natural Gas Price, Wellhead | Natural Gas Price, Citygate | Natural Gas Price, Delivered to Consumers, Residential | Natural Gas Price, Delivered to Consumers, Commercial | Natural Gas Price, Delivered to Consumers, Industrial | Natural Gas Price, Electric Power Sector | |
|---|---|---|---|---|---|---|---|---|---|
| 0 | 1976-01-01 | 1976 | 1 | 0.54 | 3.94 | 3.94 | 5.49 | 4.31 | 1.55 |
| 1 | 1976-02-01 | 1976 | 2 | 0.54 | 4.02 | 3.99 | 5.54 | 4.29 | 1.65 |
| 2 | 1976-03-01 | 1976 | 3 | 0.54 | 3.91 | 4.06 | 5.57 | 4.29 | 1.69 |
| 3 | 1976-04-01 | 1976 | 4 | 0.55 | 3.96 | 2.35 | 2.04 | 1.50 | 1.32 |
| 4 | 1976-05-01 | 1976 | 5 | 0.55 | 3.98 | 1.98 | 1.64 | 1.24 | 1.06 |
| 5 | 1976-06-01 | 1976 | 6 | 0.58 | 4.02 | 1.98 | 1.64 | 1.24 | 1.06 |
| 6 | 1976-07-01 | 1976 | 7 | 0.58 | 4.06 | 4.32 | 5.60 | 4.14 | 1.84 |
| 7 | 1976-08-01 | 1976 | 8 | 0.60 | 3.69 | 4.30 | 5.47 | 4.15 | 1.87 |
| 8 | 1976-09-01 | 1976 | 9 | 0.60 | 4.02 | 4.47 | 5.53 | 4.24 | 1.89 |
| 9 | 1976-10-01 | 1976 | 10 | 0.62 | 3.97 | 4.50 | 5.62 | 4.17 | 1.96 |
Last rows
| Date | Year | Month | Natural Gas Price, Wellhead | Natural Gas Price, Citygate | Natural Gas Price, Delivered to Consumers, Residential | Natural Gas Price, Delivered to Consumers, Commercial | Natural Gas Price, Delivered to Consumers, Industrial | Natural Gas Price, Electric Power Sector | |
|---|---|---|---|---|---|---|---|---|---|
| 542 | 2021-03-01 | 2021 | 3 | 2.25 | 4.04 | 10.51 | 7.99 | 4.40 | 3.40 |
| 543 | 2021-04-01 | 2021 | 4 | 1.89 | 3.84 | 12.25 | 8.40 | 4.00 | 3.14 |
| 544 | 2021-05-01 | 2021 | 5 | 1.94 | 4.34 | 14.13 | 8.96 | 4.12 | 3.35 |
| 545 | 2021-06-01 | 2021 | 6 | 2.54 | 4.88 | 17.73 | 9.58 | 4.15 | 3.57 |
| 546 | 2021-07-01 | 2021 | 7 | 2.59 | 5.60 | 19.94 | 9.88 | 4.73 | 4.12 |
| 547 | 2021-08-01 | 2021 | 8 | 2.86 | 5.67 | 20.98 | 10.19 | 5.01 | 4.45 |
| 548 | 2021-09-01 | 2021 | 9 | 2.71 | 6.25 | 20.25 | 10.28 | 5.57 | 5.09 |
| 549 | 2021-10-01 | 2021 | 10 | 3.03 | 6.41 | 17.50 | 10.45 | 6.84 | 5.75 |
| 550 | 2021-11-01 | 2021 | 11 | 3.35 | 6.03 | 13.29 | 10.11 | 7.03 | 5.89 |
| 551 | 2021-12-01 | 2021 | 12 | 3.35 | 5.81 | 13.13 | 10.33 | 6.74 | 5.15 |